SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweAntiguedades
AS
SELECT     idAntiguedad AS ID, idAgente AS Agente, ConceptoAntiguedad, Parametro, FechaDesde, FechaHasta, TotalDias, Anios, Meses, Dias, Manual, Recalcular, 
                      FechaCalculo
FROM         dbo.tb_Antiguedades

GO
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [PersonalDocente]
GRANT INSERT ON  [dbo].[vweAntiguedades] TO [PersonalDocente]
GRANT UPDATE ON  [dbo].[vweAntiguedades] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [PersonalDocenteDireccion]
GRANT INSERT ON  [dbo].[vweAntiguedades] TO [PersonalDocenteDireccion]
GRANT DELETE ON  [dbo].[vweAntiguedades] TO [PersonalDocenteDireccion]
GRANT UPDATE ON  [dbo].[vweAntiguedades] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [SoloVer]
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [Subsidios]
GRANT INSERT ON  [dbo].[vweAntiguedades] TO [Subsidios]
GRANT UPDATE ON  [dbo].[vweAntiguedades] TO [Subsidios]
GRANT SELECT ON  [dbo].[vweAntiguedades] TO [SubsidiosConsulta]
GO
